110. Middle Tier - Datasource Connection Pool

The data sources (fndbas and fndbasXA) are limited resources. This check will indicate if the datasource health is faulty, high utilized or requests need to wait. If Current Capacity is zero it will indicate that no connection to the database exists.

Multiple Instances: Yes (fndbas and fndbasXA: per managed server)

Interval: Every 5 minutes (288 times per day)

Status Expression
Critical If (ConnectionPool Status fndbas == “Error”) or (ConnectionPool Status fndbasXA == “Error”)

Impact Middleware Server cannot connect to the database.
Suggestion Check configuration. Possible network/firewall problems. Check if the listener is down.
Warning If (ConnectionPool Status fndbas == “Warning”) or (ConnectionPool Status fndbasXA == “Warning”) or (Current Count fndbas > 90%) or (Current Count fndbasXA > 90%) or (Average Wait fndbas > xx) or (Average Wait fndbasXA > xx) or (Current Capacity fndbas == 0) or  (Current Capacity fndbasXA == 0)

Impact Increased latency. The users notices slow responsive system. If Current Capacity is zero it will indicate that no connection to the database exists.
Suggestion Long queries to the system can cause this behavior. Connection Pool may be too small.
OK If not status Warning or Critical.
Unknown Missing application response.

Metric & Service Command line example
ConnectionPool Status fndbas  java -jar application-monitoring-metrics-cli.jar mws -host=localhost -server=<Managed Server Name> -port=<Managed Server JMX Port> -user=ifsmon -pass=<password> -request=fndbas_status -ceq=Error -weq=Warning
ConnectionPool Status fndbasXA java -jar application-monitoring-metrics-cli.jar mws -host=localhost -server=<Managed Server Name> -port=<Managed Server JMX Port> -user=ifsmon -pass=<password> -request=fndbasxa_status -ceq=Error -weq=Warning
Current Count fndbas java -jar application-monitoring-metrics-cli.jar mws -host=localhost -server=<Managed Server Name> -port=<Managed Server JMX Port> -user=ifsmon -pass=<password> -request=fndbas_current_count -wa=90
Current Count fndbasXA java -jar application-monitoring-metrics-cli.jar mws -host=localhost -server=<Managed Server Name> -port=<Managed Server JMX Port> -user=ifsmon -pass=<password> -request=fndbasxa_current_count -wa=90
Average Wait fndbas java -jar application-monitoring-metrics-cli.jar mws -host=localhost -server=<Managed Server Name> -port=<Managed Server JMX Port> -user=ifsmon -pass=<password> -request=fndbas_avg_wait -wa=500 -ca=1000
Average Wait fndbasXA java -jar application-monitoring-metrics-cli.jar mws -host=localhost -server=<Managed Server Name> -port=<Managed Server JMX Port> -user=ifsmon -pass=<password> -request=fndbasxa_avg_wait -wa=500 -ca=1000
Current Capacity fndbas java -jar application-monitoring-metrics-cli.jar mws -host=localhost -server=<Managed Server Name> -port=<Managed Server JMX Port> -user=ifsmon -pass=<password> -request=fndbas_currcapacity -cb=1 -do
Current Capacity fndbasXA java -jar application-monitoring-metrics-cli.jar mws -host=localhost -server=<Managed Server Name> -port=<Managed Server JMX Port> -user=ifsmon -pass=<password> -request=fndbasxa_currcapacity -cb=1 -do